#region Copyright (c) 2006-2012 nHydrate.org, All Rights Reserved
//--------------------------------------------------------------------- *
//                          NHYDRATE.ORG                                *
//             Copyright (c) 2006-2012 All Rights reserved              *
//                                                                      *
//                                                                      *
//This file and its contents are protected by United States and         *
//International copyright laws.  Unauthorized reproduction and/or       *
//distribution of all or any portion of the code contained herein       *
//is strictly prohibited and will result in severe civil and criminal   *
//penalties.  Any violations of this copyright will be prosecuted       *
//to the fullest extent possible under law.                             *
//                                                                      *
//THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *
//TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *
//TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *
//CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *
//THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF THE NHYDRATE GROUP *
//                                                                      *
//UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *
//PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *
//SUBSTANTIALLY THE SAME, FUNCTIONALITY AS THIS PRODUCT                 *
//                                                                      *
//THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *
//CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF NHYDRATE,          *
//THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO             *
//INSURE ITS CONFIDENTIALITY.                                           *
//                                                                      *
//THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *
//PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *
//EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *
//THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *
//SOURCE CODE CONTAINED HEREIN.                                         *
//                                                                      *
//THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *
//--------------------------------------------------------------------- *
#endregion

using System;
using System.Xml;
using nHydrate.Generator.Common;
using nHydrate.Generator.Common.GeneratorFramework;
using nHydrate.Generator.Common.Util;

namespace nHydrate.Generator.Models
{
	public class RowEntry : BaseModelObject
	{
		#region Member Variables

		protected CellEntryCollection _cellEntries = null;

		#endregion

		#region Constructor

		public RowEntry(INHydrateModelObject root)
			: base(root)
		{
			_cellEntries = new CellEntryCollection(this.Root);
		}

		#endregion

		#region Property Implementations

		public CellEntryCollection CellEntries
		{
			get { return _cellEntries; }
			set { _cellEntries = value; }
		}

		#endregion

		#region Methods

		public string GetCodeIdentifier(Table table)
		{
			try
			{
				var id = string.Empty;
				var name = string.Empty;
				var description = string.Empty;
				foreach (CellEntry cellEntry in this.CellEntries)
				{
					var column = (Column)cellEntry.ColumnRef.Object;
					var pk = (Column)table.PrimaryKeyColumns[0];
					if (column != null)
					{
						if (column.Key == pk.Key)
							id = cellEntry.Value;
						if (StringHelper.Match(column.Name, "name"))
							name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
						if (StringHelper.Match(column.Name, "description"))
							description = cellEntry.Value;
					}
				}

				if (string.IsNullOrEmpty(name)) name = description;
				return name;

			}
			catch (Exception ex)
			{
				throw;
			}

		}

		public string GetCodeIdValue(Table table)
		{
			var id = string.Empty;
			var name = string.Empty;
			var description = string.Empty;
			foreach (CellEntry cellEntry in this.CellEntries)
			{
				var column = (Column)cellEntry.ColumnRef.Object;
				var pk = (Column)table.PrimaryKeyColumns[0];
				if (column != null)
				{
					if (column.Key == pk.Key)
						id = cellEntry.Value;
					if (StringHelper.Match(column.Name, "name"))
						name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
					if (StringHelper.Match(column.Name, "description"))
						description = cellEntry.Value;
				}
			}

			if (string.IsNullOrEmpty(name)) name = description;
			return id;
		}

		public string GetCodeDescription(Table table)
		{
			var id = string.Empty;
			var name = string.Empty;
			var description = string.Empty;
			foreach (CellEntry cellEntry in this.CellEntries)
			{
				var column = (Column)cellEntry.ColumnRef.Object;
				var pk = (Column)table.PrimaryKeyColumns[0];
				if (column != null)
				{
					if (column.Key == pk.Key)
						id = cellEntry.Value;
					if (StringHelper.Match(column.Name, "name"))
						name = ValidationHelper.MakeCodeIdentifer(cellEntry.Value);
					if (StringHelper.Match(column.Name, "description"))
						description = cellEntry.Value;
				}
			}

			if (string.IsNullOrEmpty(name)) name = description;
			if (description != null) return description;
			else return "";
		}

		#endregion

		#region IXMLable Members
		public override void XmlAppend(XmlNode node)
		{
			var oDoc = node.OwnerDocument;

			//XmlHelper.AddAttribute(node, "key", this.Key);

			var cellEntriesNode = oDoc.CreateElement("cl");
			CellEntries.XmlAppend(cellEntriesNode);
			node.AppendChild(cellEntriesNode);

		}

		public override void XmlLoad(XmlNode node)
		{
			_key = XmlHelper.GetAttributeValue(node, "key", string.Empty);
			var cellEntriesNode = node.SelectSingleNode("cellEntries"); //deprecated, use "cl"
			if (cellEntriesNode == null) cellEntriesNode = node.SelectSingleNode("cl");
			this.CellEntries.XmlLoad(cellEntriesNode);

			this.Dirty = false;
		}
		#endregion

	}
}
